<?php
!defined('ADMIN') && exit('Not allowed to directly view page');
#CheckPurview('temp_Other');
require_once(DEDEINC.'/datalistcp.class.php');
setcookie("ENV_GOBACK_URL",$dedeNowurl,time()+3600,'/');

$sql = "Select d.*,h.name as hospitalname,a.name as professionsname From `#@__doctor` as d left join `#@__hospital` as h on h.id=d.hospitalid left join `#@__asktype` as a on a.id=d.professions";
$dsql->Execute('me',$sql);
while($row = $dsql->getarray())
{
	$row[recommend] = $row[recommend] ==1 ? '<p style="color:red;">推荐</p>': '';
	$row[station] = $row[station] ==1 ? '<p style="color:red;">驻站医生</p>': '';
	$doctors[] = $row;
}
$dtp = new DedeTemplate();
$dtp->LoadTemplate(DEDEADMIN.'/templets/ask_doctor_main.htm');
$dtp->Display();
?>